SQL databases

Discussion List

• 
  SqlExecutor2 does not handle Snowflake ARRAY data type * Bug?

  Answered info-rchitect 2.4K views 5 comments 0 points Most recent by Tapan December 10Using Dataiku
• 
  Window recipe not producing expected results when using DSS engine

  Question KKhatib 227 views 3 comments 0 points Most recent by Turribeach June 14Using Dataiku
• 
  Create SQL table for Dataset using python API

  Question Dima 798 views 10 comments 1 point Most recent by Marlan June 7Using Dataiku
• 
  remapping connections for API services

  Answered ✓ fjavanderspek 380 views 4 comments 0 points Most recent by fjavanderspek May 29Using Dataiku
• 
  variable expansion in SQL query endpoint

  Question fjavanderspek 553 views 3 comments 0 points Most recent by Sarina April 10Using Dataiku
• 
  Load from Oracle to Vertica

  Answered ✓ AHerrera101499 499 views 2 comments 0 points Most recent by Turribeach April 9Using Dataiku
• 
  Using date in DataIKU

  Question Niyazi 292 views 0 comments 0 points Most recent by Niyazi April 4Using Dataiku
• 
  DSS visual recipes defaulting to max column length with Redshift tables

  Answered ✓ veenacalambur 6.6K views 5 comments 2 points Most recent by Peter_R_Knight April 3Using Dataiku
• 
  Monthly Partitioning changes partition column value

  Answered ✓ Gipple 959 views 2 comments 0 points Most recent by Gipple February 23Using Dataiku
• 
  OAUTH authentication possibilities for Python library

  Question info-rchitect 1K views 4 comments 0 points Most recent by info-rchitect February 13Using Dataiku
• 
  Unable to see connections while creating new snowflake dataset

  Question Rohit1703 454 views 2 comments 0 points Most recent by Rohit1703 February 9Using Dataiku
• 
  Use a list as variable in SQL Query

  Question Sv3n-Sk4 2.2K views 2 comments 1 point Most recent by Hui Xiang January 31Using Dataiku
• 
  Recursive query in Dataiku

  Question TranhieuTX3 365 views 1 comment 0 points Most recent by Turribeach January 25Using Dataiku
• 
  Is there a way to tell dataiku to use TRUNCATE TABLE instead of DROP TABLE for snowflake datasets?

  Answered ✓ ecerulm 866 views 2 comments 0 points Most recent by Turribeach January 24Using Dataiku
• 
  Trigger a flow when variables are set

  Answered ✓ MJL 2.6K views 6 comments 0 points Most recent by Turribeach December 2023Using Dataiku
• 
  Metrics Dataset using DSS Python API

  Question anastasiosv 482 views 1 comment 0 points Most recent by Turribeach November 2023Using Dataiku
• 
  How can I make an INSERT with an SQL Query recipe?

  Question ligia_tzab 1.6K views 2 comments 0 points Most recent by Marlan November 2023Using Dataiku
• 
  Using a transaction in a SQL Script recipe

  Question MJL 436 views 0 comments 0 points Most recent by MJL October 2023Using Dataiku
• 
  INSERT query from python function endpoint

  Answered ✓ ssuhas76 569 views 1 comment 0 points Most recent by Turribeach September 2023Using Dataiku
• 
  Left join coalesce returns null values when there value

  Question ShrimpMania 2.4K views 4 comments 0 points Most recent by Turribeach September 2023Using Dataiku
• 
  Create a SQL table in POSTGRES SQL database

  Answered ✓ ssuhas76 1.1K views 1 comment 0 points Most recent by Álvaro Andrés September 2023Using Dataiku
• 
  Generating rows and 3 months avg. value

  Answered ✓ ShrimpMania 611 views 1 comment 0 points Most recent by Turribeach September 2023Using Dataiku
• 
  How to create Date variable for MTD, YTD, QTD..etc

  Question duripav1 1.4K views 3 comments 0 points Most recent by me2 September 2023Using Dataiku
• 
  Data transformation

  Question shahas71 1.9K views 7 comments 0 points Most recent by info-rchitect September 2023Using Dataiku
• 
  An alternative way to get around lack of Dataiku support for certain datatypes

  Question info-rchitect 496 views 0 comments 0 points Most recent by info-rchitect September 2023Using Dataiku
• 
  Unable to update Snowflake connection details using recipe variables

  Question Siddharth1316 1.4K views 2 comments 0 points Most recent by Turribeach September 2023Using Dataiku
• 
  Dataiku and BigQuery: Limitations

  Question Turribeach 4.4K views 1 comment 3 points Most recent by alexei-ciobanu September 2023Using Dataiku
• 
  Not Authorized error only when using SQL or Python recipes

  Answered ✓ Niyazi 2.1K views 4 comments 0 points Most recent by Niyazi September 2023Using Dataiku
• 
  Root path of the dataset does not exist

  Answered ✓ jvijayakumar2 3.6K views 4 comments 0 points Most recent by jvijayakumar2 August 2023Using Dataiku
• 
  Automatically reload schema from table

  Question ZMehdi 1K views 1 comment 0 points Most recent by JordanB June 2023Using Dataiku